IMGREET_ERD

Tables (15)

COMMENTS

  • ID (COMMENT_ID) — NUMBER — Primary key — NOT NULL
  • Field
  • ID (GREET_ID) — NUMBER — Foreign key → GREETS.ID — NOT NULL

GREETS

  • ID (GREET_ID) — NUMBER — Primary key — NOT NULL
  • Field
  • ID (USER_ID) — NUMBER — Foreign key → USERS.ID — NOT NULL

TEMPLATE_COMPONENTS

  • ID (COMPONENT_ID) — NUMBER — Primary key — NOT NULL
  • Field

USERS

  • ID (USER_ID) — NUMBER — Primary key — NOT NULL
  • Field

Untitled

    comment_reports

    • report_id — NUMBER(10)
    • reported_user_id — NUMBER(10) — NOT NULL
    • reason — CLOB
    • comment_id — NUMBER(10) — NOT NULL

    comments

    • comment_id — NUMBER(10)
    • ip_address — VARCHAR2(45)
    • nickname — VARCHAR2(255)
    • password — VARCHAR2(255)
    • content — CLOB — NOT NULL
    • invitation_id — NUMBER(10) — NOT NULL
    • created_at — TIMESTAMP

    elements

    • element_id — NUMBER(10)
    • type — VARCHAR2(50) — NOT NULL
    • category — VARCHAR2(50)
    • name — VARCHAR2(255)
    • is_paid — CHAR(1)
    • content — CLOB
    • coordinate_x — FLOAT
    • coordinate_y — FLOAT
    • size — FLOAT
    • rotation — FLOAT
    • parent_element_id — NUMBER(10)

    event_attendees

    • attendee_id — NUMBER(10)
    • name — VARCHAR2(255) — NOT NULL
    • phone — VARCHAR2(20) — NOT NULL
    • event_number — VARCHAR2(255)
    • invitation_id — NUMBER(10)

    favorites

    • favorite_id — NUMBER(10)
    • template_id — NUMBER(10) — NOT NULL
    • user_id — NUMBER(10) — NOT NULL

    images

    • image_id — NUMBER(10)
    • url — VARCHAR2(255) — NOT NULL
    • invitation_id — NUMBER(10)

    invitation_reports

    • report_id — NUMBER(10)
    • reported_user_id — NUMBER(10) — NOT NULL
    • reason — CLOB
    • invitation_id — NUMBER(10) — NOT NULL

    invitations

    • invitation_id — NUMBER(10)
    • user_id — NUMBER(10) — NOT NULL
    • title — VARCHAR2(255)
    • url — VARCHAR2(255)
    • created_at — TIMESTAMP
    • expiration_date — DATE
    • component_id — NUMBER(10)
    • allow_comments — CHAR(1)

    templates

    • template_id — NUMBER(10)
    • component_id — NUMBER(10)
    • creator_id — NUMBER(10)
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP
    • like_count — NUMBER

    users

    • user_id — NUMBER(10)
    • nickname — VARCHAR2(255) — NOT NULL
    • role — VARCHAR2(10) — NOT NULL
    • password — VARCHAR2(255) — NOT NULL
    • real_name — VARCHAR2(255)
    • phone — VARCHAR2(20)
    • created_at — TIMESTAMP