Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to specify enum values in ERD? #3400

Open
Tomperez98 opened this issue Sep 2, 2022 · 0 comments
Open

How to specify enum values in ERD? #3400

Tomperez98 opened this issue Sep 2, 2022 · 0 comments
Labels
Status: Triage Needs to be verified, categorized, etc Type: Other Not an enhancement or a bug

Comments

@Tomperez98
Copy link

I'm using mermaid to document the ERD of a service database. One of the columns has an Enum value, what's the best way to do this?

Current approach.

erDiagram
    user ||--|{ loan: has
    user {
        int id PK
        string phone_number
        string name
        string last_name
        int age
        datetime created_at
        datetime updated_at
    }

    loan {
        int id PK
        int lender_id FK "user.id"
        string  borrower_phone_number
        float loan_amount
        float interest_rate
        BillingPeriod billing_period
        datetime created_at
        datetime updated_at
    }

    BillingPeriod {
        string DAILY
        string WEEKLY
        string MONTHLY
        string YEARLY
    }
@Tomperez98 Tomperez98 added the Type: Other Not an enhancement or a bug label Sep 2, 2022
@github-actions github-actions bot added the Status: Triage Needs to be verified, categorized, etc label Sep 2, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Status: Triage Needs to be verified, categorized, etc Type: Other Not an enhancement or a bug
Projects
None yet
Development

No branches or pull requests

1 participant