풋살ERD

테이블 (7)

ADMIN (admine)

  • AdmineId (admine_id) — VARCHAR2 — 기본 키 — NOT NULL
  • Password (password) — BIGINT

COMMENT (coment)

  • UserId (user_id) — VARCHAR2 — 외래 키 → USER.UserId — NOT NULL
  • FieldId (field_id) — VARCHAR2 — 외래 키 → CONTENT.FieldId — NOT NULL
  • UserComment (user_comment) — VARCHAR2 — NOT NULL

CONTENT (content)

  • FieldId (field_id) — VARCHAR2 — 기본 키 — NOT NULL
  • FieldName (field_name) — VARCHAR2
  • FieldLocation (field_location) — VARCHAR2
  • Like (like) — BIGINT

LIST (list)

  • FieldName — VARCHAR.
  • UserName — VARCHAER
  • Time (time) — BIGINT

PICTURE (picture)

  • FieldId (field_id) — VARCHAR2 — 외래 키 → CONTENT.FieldId — NOT NULL
  • PICTURE (picture) — VARCHAR2

TIME (time)

  • FieldId (field_id) — VARCHAR2 — 외래 키 → CONTENT.FieldId — NOT NULL
  • Time (time) — BIGINT — NOT NULL

USER (user)

  • UserId (user_id) — VARCHAR2 — 기본 키 — NOT NULL
  • Password (password) — BIGINT
  • Phone (phone) — BIGINT
  • Email (email) — VARCHAR2
  • UserName (user_name) — VARCHAR2