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
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